from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey
from sqlalchemy.orm import registry
mapper_registry = registry()
Base = mapper_registry.generate_base()

class Coach(Base):
    __tablename__ = "coach"
    c_id = Column(Integer, primary_key=True)
    t_id = Column(String(10))
    c_name = Column(String(10))
    c_sex = Column(String(2))

    def __init__(self,cid=None,t_id=None,c_name=None,c_sex=None):
        self.c_id = cid
        self.t_id = t_id
        self.c_name = c_name
        self.c_sex = c_sex









